package cn.hairui.fastms.constant;

/**
 * <p>
 * <h2>数据库字段定义表</h2>
 *   <ol>规则：数组形式存储，{字段名,类型,长度,含义}</ol>
 * <h2>修改历史</h2>
 *   <ol>如有修改，请添加修改历史</ol>
 * </p>
 *
 * @author spdb/lihr3
 * @date 2020/11/2"8" 21:59
 * @copyright spdb
 */
public class FieldConstant {
    public static final String FILED_TYPE_INT = "int";
    public static final String FILED_TYPE_VARCHAR = "varchar";

    //S_USER
    public static final String[] ID = {"ID", FILED_TYPE_INT, "11", "编号"};
    public static final String[] USER_ACCOUNT = {"USER_ACCOUNT", FILED_TYPE_VARCHAR, "32", "登录帐号"};
    public static final String[] USER_NAME = {"USER_NAME", FILED_TYPE_VARCHAR, "64", "用户姓名"};
    public static final String[] USER_NICKNAME = {"USER_NICKNAME", FILED_TYPE_VARCHAR, "64", "昵称"};
    public static final String[] USER_ID_TYPE = {"USER_ID_TYPE", FILED_TYPE_VARCHAR, "8", "证件类型"};
    public static final String[] USER_ID_NO = {"USER_ID_NO", FILED_TYPE_VARCHAR, "32", "证件号码"};
    public static final String[] USER_PASSWORD = {"USER_PASSWORD", FILED_TYPE_VARCHAR, "32", "密码"};
    public static final String[] USER_TEL = {"USER_TEL", FILED_TYPE_VARCHAR, "32", "手机号码"};
    public static final String[] USER_EMAIL = {"USER_EMAIL", FILED_TYPE_VARCHAR, "32", "电子邮箱"};
    public static final String[] USER_BCH = {"USER_BCH", FILED_TYPE_VARCHAR, "8", "所属机构"};
    public static final String[] USER_STS = {"USER_STS", FILED_TYPE_VARCHAR, "8", "用户状态"};
    public static final String[] PASS_MODI_DT = {"PASS_MODI_DT", FILED_TYPE_VARCHAR, "32", "密码修改日"};
    public static final String[] CREATE_USER = {"CREATE_USER", FILED_TYPE_VARCHAR, "32", "创建人"};
    public static final String[] CREATE_TIME = {"CREATE_TIME", FILED_TYPE_VARCHAR, "32", "创建时间"};
    public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    public static final String[] UPDATE_TIME = {"UPDATE_TIME", FILED_TYPE_VARCHAR, "32", "更新时间"};
    public static final String[] LAST_LOGIN_TIME = {"LAST_LOGIN_TIME", FILED_TYPE_VARCHAR, "32", "上次登录时间"};


    //S_RESC
    public static final String[] RESC_CDE = {"RESC_CDE", FILED_TYPE_VARCHAR, "32", "资源代码"};
    public static final String[] RESC_DESC = {"RESC_DESC", FILED_TYPE_VARCHAR, "64", "中文名"};
    public static final String[] RESC_URL = {"RESC_URL", FILED_TYPE_VARCHAR, "255", "资源URL"};
    public static final String[] RESC_PARENTID = {"RESC_PARENTID", FILED_TYPE_VARCHAR, "32", "上级资源"};
    public static final String[] RESC_ORDERID = {"RESC_ORDERID", FILED_TYPE_VARCHAR, "16", "排序字段"};
    public static final String[] RESC_ICON = {"RESC_ICON", FILED_TYPE_VARCHAR, "64", "资源图标"};
    public static final String[] RESC_RMK = {"RESC_RMK", FILED_TYPE_VARCHAR, "255", "备注"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    //public static final String[] UPDATE_TIME = {"UPDATE_TIME", FILED_TYPE_VARCHAR, "32", "更新时间"};

    //S_ROLE
    public static final String[] ROLE_CDE = {"ROLE_CDE", FILED_TYPE_VARCHAR, "32", "角色代码"};
    public static final String[] ROLE_NAME = {"ROLE_NAME", FILED_TYPE_VARCHAR, "32", "角色名称"};
    public static final String[] ROLE_STS = {"ROLE_STS", FILED_TYPE_VARCHAR, "8", "角色状态"};
    public static final String[] ROLE_RMK = {"ROLE_RMK", FILED_TYPE_VARCHAR, "255", "备注"};
    //public static final String[] CREATE_USER = {"CREATE_USER", FILED_TYPE_VARCHAR, "32", "创建人"};
    //public static final String[] CREATE_TIME = {"CREATE_TIME", FILED_TYPE_VARCHAR, "32", "创建时间"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "最新变更用户"};
    //public static final String[] UPDATE_TIME = {"UPDATE_TIME", FILED_TYPE_VARCHAR, "32", "最新变更时间"};

    //S_USER_ROLE
    //public static final String[] UUID = {"UUID", FILED_TYPE_VARCHAR, "64", "主键"};
    //public static final String[] ROLE_CDE = {"ROLE_CDE", FILED_TYPE_VARCHAR, "32", "角色代码"};
    //public static final String[] USER_ACCOUNT = {"USER_ACCOUNT", FILED_TYPE_VARCHAR, "32", "登录帐号"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    //public static final String[] UPDATE_TIME = {"UPDATE_TIME", FILED_TYPE_VARCHAR, "32", "更新时间"};

    //S_DIC
    public static final String[] UUID = {"UUID", FILED_TYPE_VARCHAR, "64", "主键"};
    public static final String[] DIC_NAME = {"DIC_NAME", FILED_TYPE_VARCHAR, "32", "字典名称"};
    public static final String[] DIC_DESC = {"DIC_DESC", FILED_TYPE_VARCHAR, "64", "字典描述"};
    public static final String[] KEY_CDE = {"KEY_CDE", FILED_TYPE_VARCHAR, "32", "代码"};
    public static final String[] KEY_DESC = {"KEY_DESC", FILED_TYPE_VARCHAR, "64", "代码描述"};
    public static final String[] DIC_STS = {"DIC_STS", FILED_TYPE_VARCHAR, "8", "状态"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    //public static final String[] UPDATE_TIME = {"ROLE_RMK", FILED_TYPE_VARCHAR, "32", "更新时间"};
    public static final String[] MODULE = {"MODULE", FILED_TYPE_VARCHAR, "8", "模块"};

    //S_BCH
    public static final String[] BCH_CDE = {"BCH_CDE", FILED_TYPE_VARCHAR, "32", "机构代码"};
    public static final String[] BCH_NAME = {"BCH_NAME", FILED_TYPE_VARCHAR, "128", "机构名称"};
    public static final String[] BCH_CONT_USR = {"BCH_CONT_USR", FILED_TYPE_VARCHAR, "32", "机构联系人姓名"};
    public static final String[] BCH_CONT_TEL = {"BCH_CONT_TEL", FILED_TYPE_VARCHAR, "32", "机构联系人电话"};
    public static final String[] BCH_ADDR = {"BCH_ADDR", FILED_TYPE_VARCHAR, "128", "机构地址"};
    public static final String[] BCH_STS = {"BCH_STS", FILED_TYPE_VARCHAR, "8", "状态"};
    //public static final String[] CREATE_USER = {"CREATE_USER", FILED_TYPE_VARCHAR, "32", "创建人"};
    //public static final String[] CREATE_TIME = {"CREATE_TIME", FILED_TYPE_VARCHAR, "32", "创建时间"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    //public static final String[] UPDATE_TIME = {"ROLE_RMK", FILED_TYPE_VARCHAR, "32", "更新时间"};

    //S_CONFIG
    public static final String[] CFG_ID = {"CFG_ID", FILED_TYPE_INT, "11", "序号"};
    public static final String[] CFG_KEY = {"CFG_KEY", FILED_TYPE_VARCHAR, "32", "参数代码"};
    public static final String[] CFG_VALUE = {"CFG_VALUE", FILED_TYPE_VARCHAR, "64", "参数值"};
    public static final String[] CFG_NAME = {"CFG_NAME", FILED_TYPE_VARCHAR, "64", "参数含义"};
    public static final String[] CFG_STS = {"CFG_STS", FILED_TYPE_VARCHAR, "8", "状态"};
    public static final String[] PARAM_BLOCK = {"PARAM_BLOCK", FILED_TYPE_VARCHAR, "8", "参数块名称"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    //public static final String[] UPDATE_TIME = {"ROLE_RMK", FILED_TYPE_VARCHAR, "32", "更新时间"};

    //S_USER_THEME
    //public static final String[] USER_ACCOUNT = {"USER_ACCOUNT", FILED_TYPE_VARCHAR, "32", "用户帐号"};
    public static final String[] THEME_ID = {"THEME_ID", FILED_TYPE_VARCHAR, "32", "用户主题"};

    //S_MSG
    public static final String[] MSG_CDE = {"MSG_CDE", FILED_TYPE_VARCHAR, "32", "消息编码"};
    public static final String[] STATUS_CODE = {"STATUS_CODE", FILED_TYPE_INT, "11", "状态码"};
    public static final String[] TITLE = {"TITLE", FILED_TYPE_VARCHAR, "64", "提示"};
    public static final String[] MESSAGE = {"MESSAGE", FILED_TYPE_VARCHAR, "256", "消息内容"};
    //public static final String[] PARAM_BLOCK = {"PARAM_BLOCK", FILED_TYPE_VARCHAR, "8", "参数块名称"};
    //public static final String[] UPDATE_USER = {"UPDATE_USER", FILED_TYPE_VARCHAR, "32", "更新人"};
    //public static final String[] UPDATE_TIME = {"ROLE_RMK", FILED_TYPE_VARCHAR, "32", "更新时间"};

}
